BulletCashflow2
1. Description
Bullet Cashflow - 2 cashflow type generates a single cashflow for each record based on the mapping provided for principal amount, maturity date, and interest amount calculated using interest rate, account open date / as on date.
2. Screen Configuration
Here, since AccOpenDate is present and mapped, Interest Amount will be calculated according to case 1 in the below derivation logic where Principal Amount = OutBal, Interest Rate = IntRate, Maturity Date = MaturityDate, int_basis is the day convention used, AccruedIntBal is the amount of Interest to be added to the Principal amount.Number of days is calculated between AccOpenDate and MaturityDate.Click ⬇️ to download the test-bed.
3. Cashflow Derivation Logic
Case 1: If Account Open Date is present and mapped in required fields,
ACCOUNT_ID : ACC1001
OUTSTANDING_AMOUNT: 1000.00
INTEREST_RATE: 10.00
ACCOUNT_OPEN_DATE: 12-01-2023
MATURITY_DATE: 31-01-2024
INTEREST_BASIS_CONVENTION: ActualBy365
A single cashfow for account_id ' ACC1001' will get generate with below values,
number of days between account open date and maturity date = 61
so, interest amount = (outstanding_amount * interest_rate * (number of days between account open date and maturity date)) / 100 * number of days in a year
interest amount = 16.7123
principal_amount = 1000.00
cashflow_date = 31-01-2024
Case 2: If Account Open Date is not present or it is not mapped in required fields, As On Date will be considered as account start date.
let as_on_date be 01-01-2024
ACCOUNT_ID : ACC1001
OUTSTANDING_AMOUNT: 1000.00
INTEREST_RATE: 10.00
MATURITY_DATE: 31-01-2024
INTEREST_BASIS_CONVENTION: ActualBy365
A single cashfow for account_id ' ACC1001' will get generate with below values,
number of days between as on date and maturity date = 30
so, interest amount = (outstanding_amount * interest_rate * (number of days between as on date and maturity date)) / 100 * number of days in a year
interest amount = 8.2191
principal_amount = 1000.00
cashflow_date = 31-01-2024
4. Required Fields
| # | Parameters | Description | Is_Mandatory_Field |
|---|---|---|---|
| 1 | account_id | The field which needs to be stamped as account id. | YES |
| 2 | principal_amount | The amount field which needs to stamped as principal amount. | YES |
| 3 | interest_rate | The interest rate field which will be utilised for calculation of interest amount. | YES |
| 4 | account_interest_basis | Day convention to be used. | YES |
| 5 | maturity_date | The date field which needs to stamped as cashflow date and will be considered as account end date. | YES |
| 6 | account_open_date | The date field which will be considered as account start date. | NO |
| 7 | accrued_interest_amount | Amount of interest to be added in the principal amount. | NO |
5. Working Excel
Click ⬇️ to download the excel calculation.